Everything about Write-write Conflict totally explained
In
computer science, in the field of
databases,
Write-Write Conflict, also known as
overwriting uncommitted data is a computational anomaly associated with interleaved execution of
transactions.
Given a
schedule H
note that there's no read in this schedule. The writes are called
blind writes.
We have a
lost update. Any attempts to make this schedule serial would give off two different results (either T1's version of A/B is shown, or T2's version of A and B is shown), and wouldn't be the same as the above schedule. This schedule wouldn't be
serializable.
Strict 2PL, overcomes this inconsistency by locking T1 out from B. Unfortunately,
deadlocks are something Strict 2PL doesn't overcome all the time.
Further Information
Get more info on 'Write-write Conflict'.
|
External Link Exchanges
Do you know how hard it is to get a link from a large encyclopaedia? Well we're different and will prove it. To get a link from us just add the following HTML to your site on a relevant page:
<a href="http://write-write_conflict.totallyexplained.com">Write-Write conflict Totally Explained</a>
Then simply click through this link from your web page. Our crawlers will verify your link, extract the title of your web page and instantly add a link back to it. If you like you can remove the words Totally Explained and embed the link in article text.
As long as your link remains in place, we'll keep our link to you right here. Please play fair - our crawlers are watching. Your site must be closely related to this one's topic. Any kind of spamming, dubious practises or removing the link will result in your link from us being dropped and, potentially, your whole site being banned. |
